Pandas Profiling Report

Dataset statistics

Number of variables	21
Number of observations	42307
Missing cells	1771
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.7 MiB
Average record size in memory	116.1 B

Variable types

Numeric	8
Categorical	13

Alerts

`DisbursementDate` has a high cardinality: 916 distinct values	High cardinality
`ApprovalDate` has a high cardinality: 3868 distinct values	High cardinality
`City` has a high cardinality: 2703 distinct values	High cardinality
`State` has a high cardinality: 51 distinct values	High cardinality
`BankState` has a high cardinality: 51 distinct values	High cardinality
`DisbursementGross` has a high cardinality: 2694 distinct values	High cardinality
`GrAppv` has a high cardinality: 1425 distinct values	High cardinality
`SBA_Appv` has a high cardinality: 2005 distinct values	High cardinality
`BankState` is highly overall correlated with `State`	High correlation
`State` is highly overall correlated with `BankState`	High correlation
`LowDoc` is highly imbalanced (63.8%)	Imbalance
`MIS_Status` is highly imbalanced (50.8%)	Imbalance
`RevLineCr` has 1079 (2.6%) missing values	Missing
`LowDoc` has 531 (1.3%) missing values	Missing
`Unnamed: 0` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`NoEmp` has 2994 (7.1%) zeros	Zeros
`CreateJob` has 28889 (68.3%) zeros	Zeros
`RetainedJob` has 26056 (61.6%) zeros	Zeros
`FranchiseCode` has 26392 (62.4%) zeros	Zeros
`Sector` has 9798 (23.2%) zeros	Zeros

Reproduction

Analysis started	2024-01-23 03:29:25.004749
Analysis finished	2024-01-23 03:29:30.243696
Duration	5.24 seconds
Software version	ydata-profiling vv4.6.2
Download configuration	config.json

Unnamed: 0
Real number (ℝ)

UNIFORM UNIQUE

Distinct	42307
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21153

Minimum	0
Maximum	42306
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	330.7 KiB

Quantile statistics

Minimum	0
5-th percentile	2115.3
Q1	10576.5
median	21153
Q3	31729.5
95-th percentile	40190.7
Maximum	42306
Range	42306
Interquartile range (IQR)	21153

Descriptive statistics

Standard deviation	12213.123
Coefficient of variation (CV)	0.57737074
Kurtosis	-1.2
Mean	21153
Median Absolute Deviation (MAD)	10577
Skewness	0
Sum	8.9491997 × 10⁸
Variance	1.4916038 × 10⁸
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
28199	1	< 0.1%
28201	1	< 0.1%
28202	1	< 0.1%
28203	1	< 0.1%
28204	1	< 0.1%
28205	1	< 0.1%
28206	1	< 0.1%
28207	1	< 0.1%
28208	1	< 0.1%
Other values (42297)	42297	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
42306	1	< 0.1%
42305	1	< 0.1%
42304	1	< 0.1%
42303	1	< 0.1%
42302	1	< 0.1%
42301	1	< 0.1%
42300	1	< 0.1%
42299	1	< 0.1%
42298	1	< 0.1%
42297	1	< 0.1%

Term
Real number (ℝ)

Distinct	228
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	108.60167

Minimum	0
Maximum	360
Zeros	94
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	330.7 KiB

Quantile statistics

Minimum	0
5-th percentile	13
Q1	56
median	82
Q3	168
95-th percentile	293
Maximum	360
Range	360
Interquartile range (IQR)	112

Descriptive statistics

Standard deviation	84.569847
Coefficient of variation (CV)	0.77871587
Kurtosis	-0.28186028
Mean	108.60167
Median Absolute Deviation (MAD)	30
Skewness	1.0246757
Sum	4594611
Variance	7152.0589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
82	3649	8.6%
83	2863	6.8%
84	1546	3.7%
57	1325	3.1%
81	1300	3.1%
58	1295	3.1%
59	1161	2.7%
56	1046	2.5%
240	892	2.1%
241	875	2.1%
Other values (218)	26355	62.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	94	0.2%
1	54	0.1%
2	75	0.2%
3	62	0.1%
4	91	0.2%
5	140	0.3%
6	145	0.3%
7	158	0.4%
8	188	0.4%
9	232	0.5%

Value	Count	Frequency (%)
360	1	< 0.1%
325	7	< 0.1%
312	11	< 0.1%
311	22	0.1%
310	19	< 0.1%
309	45	0.1%
308	69	0.2%
306	72	0.2%
303	122	0.3%
302	130	0.3%

NoEmp
Real number (ℝ)

ZEROS

Distinct	196
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.7043043

Minimum	0
Maximum	202
Zeros	2994
Zeros (%)	7.1%
Negative	0
Negative (%)	0.0%
Memory size	330.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	4
Q3	12
95-th percentile	40
Maximum	202
Range	202
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	17.488022
Coefficient of variation (CV)	1.8020892
Kurtosis	40.742751
Mean	9.7043043
Median Absolute Deviation (MAD)	3
Skewness	5.4942159
Sum	410560
Variance	305.83092
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	5563	13.1%
2	5518	13.0%
4	4902	11.6%
1	4433	10.5%
5	3146	7.4%
0	2994	7.1%
6	1691	4.0%
15	975	2.3%
16	914	2.2%
7	901	2.1%
Other values (186)	11270	26.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2994	7.1%
1	4433	10.5%
2	5518	13.0%
3	5563	13.1%
4	4902	11.6%
5	3146	7.4%
6	1691	4.0%
7	901	2.1%
8	602	1.4%
9	544	1.3%

Value	Count	Frequency (%)
202	1	< 0.1%
198	1	< 0.1%
197	2	< 0.1%
195	1	< 0.1%
194	2	< 0.1%
193	2	< 0.1%
192	2	< 0.1%
191	3	< 0.1%
189	3	< 0.1%
188	2	< 0.1%

NewExist
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	330.7 KiB

1.0	33405
2.0	8902

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	126921
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	33405	79.0%
2.0	8902	21.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	33405	79.0%
2.0	8902	21.0%

Most occurring characters

Value	Count	Frequency (%)
.	42307	33.3%
0	42307	33.3%
1	33405	26.3%
2	8902	7.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	84614	66.7%
Other Punctuation	42307	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	42307	50.0%
1	33405	39.5%
2	8902	10.5%

Other Punctuation

Value	Count	Frequency (%)
.	42307	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	126921	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	42307	33.3%
0	42307	33.3%
1	33405	26.3%
2	8902	7.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	126921	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	42307	33.3%
0	42307	33.3%
1	33405	26.3%
2	8902	7.0%

CreateJob
Real number (ℝ)

ZEROS

Distinct	49
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1837285

Minimum	0
Maximum	70
Zeros	28889
Zeros (%)	68.3%
Negative	0
Negative (%)	0.0%
Memory size	330.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	13
Maximum	70
Range	70
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	5.0939801
Coefficient of variation (CV)	2.3326985
Kurtosis	23.628207
Mean	2.1837285
Median Absolute Deviation (MAD)	0
Skewness	4.0134768
Sum	92387
Variance	25.948633
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
0	28889	68.3%
3	3293	7.8%
1	2519	6.0%
4	1334	3.2%
8	665	1.6%
9	579	1.4%
2	548	1.3%
10	511	1.2%
7	484	1.1%
11	448	1.1%
Other values (39)	3037	7.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	28889	68.3%
1	2519	6.0%
2	548	1.3%
3	3293	7.8%
4	1334	3.2%
5	73	0.2%
6	250	0.6%
7	484	1.1%
8	665	1.6%
9	579	1.4%

Value	Count	Frequency (%)
70	1	< 0.1%
60	3	< 0.1%
57	5	< 0.1%
56	5	< 0.1%
50	6	< 0.1%
48	12	< 0.1%
47	15	< 0.1%
46	19	< 0.1%
45	16	< 0.1%
40	17	< 0.1%

RetainedJob
Real number (ℝ)

ZEROS

Distinct	83
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4781478

Minimum	0
Maximum	140
Zeros	26056
Zeros (%)	61.6%
Negative	0
Negative (%)	0.0%
Memory size	330.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	15
Maximum	140
Range	140
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	8.1136484
Coefficient of variation (CV)	2.3327497
Kurtosis	40.299963
Mean	3.4781478
Median Absolute Deviation (MAD)	0
Skewness	5.1823038
Sum	147150
Variance	65.83129
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	26056	61.6%
1	3846	9.1%
8	1227	2.9%
9	1060	2.5%
3	1057	2.5%
7	986	2.3%
10	837	2.0%
2	803	1.9%
11	795	1.9%
12	769	1.8%
Other values (73)	4871	11.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	26056	61.6%
1	3846	9.1%
2	803	1.9%
3	1057	2.5%
4	687	1.6%
5	329	0.8%
6	575	1.4%
7	986	2.3%
8	1227	2.9%
9	1060	2.5%

Value	Count	Frequency (%)
140	1	< 0.1%
136	1	< 0.1%
130	1	< 0.1%
118	1	< 0.1%
102	2	< 0.1%
100	4	< 0.1%
95	4	< 0.1%
91	7	< 0.1%
90	6	< 0.1%
87	7	< 0.1%

FranchiseCode
Real number (ℝ)

ZEROS

Distinct	271
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1955.056

Minimum	0
Maximum	90709
Zeros	26392
Zeros (%)	62.4%
Negative	0
Negative (%)	0.0%
Memory size	330.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	1
Maximum	90709
Range	90709
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	10541.389
Coefficient of variation (CV)	5.3918602
Kurtosis	35.690306
Mean	1955.056
Median Absolute Deviation (MAD)	0
Skewness	5.919311
Sum	82712555
Variance	1.1112088 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	26392	62.4%
1	14033	33.2%
960	182	0.4%
27760	21	< 0.1%
74750	20	< 0.1%
72590	18	< 0.1%
73000	18	< 0.1%
73675	15	< 0.1%
34850	15	< 0.1%
36680	14	< 0.1%
Other values (261)	1579	3.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	26392	62.4%
1	14033	33.2%
960	182	0.4%
5725	1	< 0.1%
6410	1	< 0.1%
9120	1	< 0.1%
9450	1	< 0.1%
10482	1	< 0.1%
10494	1	< 0.1%
10528	3	< 0.1%

Value	Count	Frequency (%)
90709	1	< 0.1%
89769	2	< 0.1%
89655	1	< 0.1%
89640	2	< 0.1%
89352	1	< 0.1%
89350	1	< 0.1%
88875	2	< 0.1%
88355	1	< 0.1%
87350	3	< 0.1%
86720	3	< 0.1%

RevLineCr
Categorical

MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	1079
Missing (%)	2.6%
Memory size	41.6 KiB

N	27618
Y	7353
0	5561
T	696

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	41228
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	0
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	27618	65.3%
Y	7353	17.4%
0	5561	13.1%
T	696	1.6%
(Missing)	1079	2.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	27618	67.0%
y	7353	17.8%
0	5561	13.5%
t	696	1.7%

Most occurring characters

Value	Count	Frequency (%)
N	27618	67.0%
Y	7353	17.8%
0	5561	13.5%
T	696	1.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	35667	86.5%
Decimal Number	5561	13.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	27618	77.4%
Y	7353	20.6%
T	696	2.0%

Decimal Number

Value	Count	Frequency (%)
0	5561	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	35667	86.5%
Common	5561	13.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	27618	77.4%
Y	7353	20.6%
T	696	2.0%

Common

Value	Count	Frequency (%)
0	5561	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	41228	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	27618	67.0%
Y	7353	17.8%
0	5561	13.5%
T	696	1.7%

LowDoc
Categorical

IMBALANCE MISSING

Distinct	6
Distinct (%)	< 0.1%
Missing	531
Missing (%)	1.3%
Memory size	41.7 KiB

N	34313
Y	5277
0	684
A	570
S	540

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	41776
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	34313	81.1%
Y	5277	12.5%
0	684	1.6%
A	570	1.3%
S	540	1.3%
C	392	0.9%
(Missing)	531	1.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	34313	82.1%
y	5277	12.6%
0	684	1.6%
a	570	1.4%
s	540	1.3%
c	392	0.9%

Most occurring characters

Value	Count	Frequency (%)
N	34313	82.1%
Y	5277	12.6%
0	684	1.6%
A	570	1.4%
S	540	1.3%
C	392	0.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	41092	98.4%
Decimal Number	684	1.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	34313	83.5%
Y	5277	12.8%
A	570	1.4%
S	540	1.3%
C	392	1.0%

Decimal Number

Value	Count	Frequency (%)
0	684	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	41092	98.4%
Common	684	1.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	34313	83.5%
Y	5277	12.8%
A	570	1.4%
S	540	1.3%
C	392	1.0%

Common

Value	Count	Frequency (%)
0	684	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	41776	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	34313	82.1%
Y	5277	12.6%
0	684	1.6%
A	570	1.4%
S	540	1.3%
C	392	0.9%

DisbursementDate
Categorical

HIGH CARDINALITY

Distinct	916
Distinct (%)	2.2%
Missing	150
Missing (%)	0.4%
Memory size	122.2 KiB

30-Nov-03	1634
31-Jul-95	1480
31-Dec-05	1076
31-Jan-98	878
31-Jan-05	871
Other values (911)	36218

Length

Max length	9
Median length	9
Mean length	8.93695
Min length	8

Characters and Unicode

Total characters	376755
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	31-Jan-98
2nd row	31-Oct-93
3rd row	31-Aug-01
4th row	31-Aug-07
5th row	8-Jun-83

Common Values

Value	Count	Frequency (%)
30-Nov-03	1634	3.9%
31-Jul-95	1480	3.5%
31-Dec-05	1076	2.5%
31-Jan-98	878	2.1%
31-Jan-05	871	2.1%
30-Nov-04	830	2.0%
28-Feb-05	694	1.6%
30-Apr-95	689	1.6%
31-Aug-07	675	1.6%
30-Apr-00	540	1.3%
Other values (906)	32790	77.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
30-nov-03	1634	3.9%
31-jul-95	1480	3.5%
31-dec-05	1076	2.6%
31-jan-98	878	2.1%
31-jan-05	871	2.1%
30-nov-04	830	2.0%
28-feb-05	694	1.6%
30-apr-95	689	1.6%
31-aug-07	675	1.6%
30-apr-00	540	1.3%
Other values (906)	32790	77.8%

Most occurring characters

Value	Count	Frequency (%)
-	84314	22.4%
0	39549	10.5%
3	36554	9.7%
1	31284	8.3%
9	19493	5.2%
J	12359	3.3%
u	10612	2.8%
5	9206	2.4%
e	9024	2.4%
a	8906	2.4%
Other values (23)	115454	30.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	165970	44.1%
Dash Punctuation	84314	22.4%
Lowercase Letter	84314	22.4%
Uppercase Letter	42157	11.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	10612	12.6%
e	9024	10.7%
a	8906	10.6%
p	7821	9.3%
n	7786	9.2%
c	7217	8.6%
r	6879	8.2%
v	4691	5.6%
o	4691	5.6%
l	4573	5.4%
Other values (4)	12114	14.4%

Decimal Number

Value	Count	Frequency (%)
0	39549	23.8%
3	36554	22.0%
1	31284	18.8%
9	19493	11.7%
5	9206	5.5%
8	7673	4.6%
2	7068	4.3%
7	5596	3.4%
6	4992	3.0%
4	4555	2.7%

Uppercase Letter

Value	Count	Frequency (%)
J	12359	29.3%
A	7894	18.7%
N	4691	11.1%
M	4224	10.0%
O	3965	9.4%
D	3252	7.7%
F	2910	6.9%
S	2862	6.8%

Dash Punctuation

Value	Count	Frequency (%)
-	84314	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	250284	66.4%
Latin	126471	33.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
J	12359	9.8%
u	10612	8.4%
e	9024	7.1%
a	8906	7.0%
A	7894	6.2%
p	7821	6.2%
n	7786	6.2%
c	7217	5.7%
r	6879	5.4%
N	4691	3.7%
Other values (12)	43282	34.2%

Common

Value	Count	Frequency (%)
-	84314	33.7%
0	39549	15.8%
3	36554	14.6%
1	31284	12.5%
9	19493	7.8%
5	9206	3.7%
8	7673	3.1%
2	7068	2.8%
7	5596	2.2%
6	4992	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	376755	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	84314	22.4%
0	39549	10.5%
3	36554	9.7%
1	31284	8.3%
9	19493	5.2%
J	12359	3.3%
u	10612	2.8%
5	9206	2.4%
e	9024	2.4%
a	8906	2.4%
Other values (23)	115454	30.6%

MIS_Status
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	330.7 KiB

1	37767
0	4540

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	42307
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Most occurring characters

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	42307	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	42307	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42307	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Sector
Real number (ℝ)

ZEROS

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.933439

Minimum	0
Maximum	81
Zeros	9798
Zeros (%)	23.2%
Negative	0
Negative (%)	0.0%
Memory size	330.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	22
median	33
Q3	44
95-th percentile	72
Maximum	81
Range	81
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	22.291386
Coefficient of variation (CV)	0.67686178
Kurtosis	-0.89972227
Mean	32.933439
Median Absolute Deviation (MAD)	11
Skewness	-0.11631806
Sum	1393315
Variance	496.90589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
0	9798	23.2%
42	7337	17.3%
33	5050	11.9%
44	3868	9.1%
23	3867	9.1%
61	2505	5.9%
72	2478	5.9%
22	1998	4.7%
62	1191	2.8%
53	896	2.1%
Other values (14)	3319	7.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9798	23.2%
11	7	< 0.1%
21	28	0.1%
22	1998	4.7%
23	3867	9.1%
31	138	0.3%
32	865	2.0%
33	5050	11.9%
42	7337	17.3%
44	3868	9.1%

Value	Count	Frequency (%)
81	169	0.4%
72	2478	5.9%
71	337	0.8%
62	1191	2.8%
61	2505	5.9%
56	672	1.6%
55	29	0.1%
54	267	0.6%
53	896	2.1%
52	84	0.2%

ApprovalDate
Categorical

HIGH CARDINALITY

Distinct	3868
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Memory size	242.0 KiB

7-Oct-03	1347
10-May-07	661
26-Aug-04	620
26-Oct-99	595
13-Nov-08	422
Other values (3863)	38662

Length

Max length	9
Median length	9
Mean length	8.7187936
Min length	8

Characters and Unicode

Total characters	368866
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	726 ?
Unique (%)	1.7%

Sample

1st row	22-Sep-06
2nd row	30-Jun-92
3rd row	18-Apr-01
4th row	6-Oct-03
5th row	17-Dec-99

Common Values

Value	Count	Frequency (%)
7-Oct-03	1347	3.2%
10-May-07	661	1.6%
26-Aug-04	620	1.5%
26-Oct-99	595	1.4%
13-Nov-08	422	1.0%
26-Jan-07	359	0.8%
14-Mar-03	330	0.8%
22-Feb-08	324	0.8%
22-Aug-00	295	0.7%
15-Feb-95	263	0.6%
Other values (3858)	37091	87.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
7-oct-03	1347	3.2%
10-may-07	661	1.6%
26-aug-04	620	1.5%
26-oct-99	595	1.4%
13-nov-08	422	1.0%
26-jan-07	359	0.8%
14-mar-03	330	0.8%
22-feb-08	324	0.8%
22-aug-00	295	0.7%
15-feb-95	263	0.6%
Other values (3858)	37091	87.7%

Most occurring characters

Value	Count	Frequency (%)
-	84614	22.9%
0	33007	8.9%
1	23038	6.2%
2	21109	5.7%
9	20658	5.6%
3	11777	3.2%
7	10586	2.9%
a	10471	2.8%
6	10289	2.8%
u	10052	2.7%
Other values (23)	133265	36.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	157331	42.7%
Dash Punctuation	84614	22.9%
Lowercase Letter	84614	22.9%
Uppercase Letter	42307	11.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	10471	12.4%
u	10052	11.9%
e	9917	11.7%
c	8022	9.5%
r	7006	8.3%
p	6724	7.9%
n	6437	7.6%
t	4751	5.6%
g	3935	4.7%
v	3908	4.6%
Other values (4)	13391	15.8%

Decimal Number

Value	Count	Frequency (%)
0	33007	21.0%
1	23038	14.6%
2	21109	13.4%
9	20658	13.1%
3	11777	7.5%
7	10586	6.7%
6	10289	6.5%
8	9129	5.8%
4	9085	5.8%
5	8653	5.5%

Uppercase Letter

Value	Count	Frequency (%)
J	9443	22.3%
M	7145	16.9%
A	7143	16.9%
O	4751	11.2%
N	3908	9.2%
S	3516	8.3%
D	3271	7.7%
F	3130	7.4%

Dash Punctuation

Value	Count	Frequency (%)
-	84614	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	241945	65.6%
Latin	126921	34.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	10471	8.3%
u	10052	7.9%
e	9917	7.8%
J	9443	7.4%
c	8022	6.3%
M	7145	5.6%
A	7143	5.6%
r	7006	5.5%
p	6724	5.3%
n	6437	5.1%
Other values (12)	44561	35.1%

Common

Value	Count	Frequency (%)
-	84614	35.0%
0	33007	13.6%
1	23038	9.5%
2	21109	8.7%
9	20658	8.5%
3	11777	4.9%
7	10586	4.4%
6	10289	4.3%
8	9129	3.8%
4	9085	3.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	368866	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	84614	22.9%
0	33007	8.9%
1	23038	6.2%
2	21109	5.7%
9	20658	5.6%
3	11777	3.2%
7	10586	2.9%
a	10471	2.8%
6	10289	2.8%
u	10052	2.7%
Other values (23)	133265	36.1%

ApprovalFY
Real number (ℝ)

Distinct	38
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2001.5378

Minimum	1974
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	330.7 KiB

Quantile statistics

Minimum	1974
5-th percentile	1991
Q1	1997
median	2003
Q3	2006
95-th percentile	2010
Maximum	2014
Range	40
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	5.8605268
Coefficient of variation (CV)	0.0029280121
Kurtosis	0.16185187
Mean	2001.5378
Median Absolute Deviation (MAD)	4
Skewness	-0.69419236
Sum	84679059
Variance	34.345775
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
2004	4708	11.1%
2007	3777	8.9%
2006	3314	7.8%
2003	3293	7.8%
2005	2712	6.4%
1995	2552	6.0%
2000	2295	5.4%
1996	1739	4.1%
2002	1726	4.1%
2008	1723	4.1%
Other values (28)	14468	34.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1974	4	< 0.1%
1977	5	< 0.1%
1979	21	< 0.1%
1980	56	0.1%
1981	13	< 0.1%
1982	78	0.2%
1983	80	0.2%
1984	79	0.2%
1985	134	0.3%
1986	77	0.2%

Value	Count	Frequency (%)
2014	9	< 0.1%
2013	105	0.2%
2012	318	0.8%
2011	781	1.8%
2010	948	2.2%
2009	1158	2.7%
2008	1723	4.1%
2007	3777	8.9%
2006	3314	7.8%
2005	2712	6.4%

City
Categorical

HIGH CARDINALITY

Distinct	2703
Distinct (%)	6.4%
Missing	0
Missing (%)	0.0%
Memory size	168.4 KiB

HOUSTON	1220
PITTSBURGH	955
SALT LAKE CITY	656
PHILADELPHIA	612
NASHVILLE	599
Other values (2698)	38265

Length

Max length	30
Median length	27
Mean length	8.8926892
Min length	3

Characters and Unicode

Total characters	376223
Distinct characters	65
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	827 ?
Unique (%)	2.0%

Sample

1st row	PHOENIX
2nd row	MCALESTER
3rd row	HAWTHORNE
4th row	NASHVILLE
5th row	POMONA

Common Values

Value	Count	Frequency (%)
HOUSTON	1220	2.9%
PITTSBURGH	955	2.3%
SALT LAKE CITY	656	1.6%
PHILADELPHIA	612	1.4%
NASHVILLE	599	1.4%
POMONA	584	1.4%
CLARENCE	535	1.3%
NEW YORK	475	1.1%
ORLANDO	470	1.1%
SAN DIEGO	444	1.0%
Other values (2693)	35757	84.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
city	1492	2.7%
san	1325	2.4%
houston	1224	2.3%
pittsburgh	958	1.8%
lake	812	1.5%
salt	716	1.3%
new	616	1.1%
philadelphia	614	1.1%
nashville	600	1.1%
pomona	584	1.1%
Other values (2347)	45399	83.5%

Most occurring characters

Value	Count	Frequency (%)
A	36799	9.8%
E	32773	8.7%
O	29514	7.8%
L	29423	7.8%
N	28734	7.6%
I	24008	6.4%
S	23939	6.4%
R	22162	5.9%
T	20421	5.4%
C	13141	3.5%
Other values (55)	115309	30.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	353936	94.1%
Space Separator	12034	3.2%
Lowercase Letter	9453	2.5%
Other Punctuation	370	0.1%
Open Punctuation	262	0.1%
Close Punctuation	151	< 0.1%
Decimal Number	10	< 0.1%
Dash Punctuation	6	< 0.1%
Modifier Symbol	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	36799	10.4%
E	32773	9.3%
O	29514	8.3%
L	29423	8.3%
N	28734	8.1%
I	24008	6.8%
S	23939	6.8%
R	22162	6.3%
T	20421	5.8%
C	13141	3.7%
Other values (16)	93022	26.3%

Lowercase Letter

Value	Count	Frequency (%)
o	1044	11.0%
e	998	10.6%
a	940	9.9%
n	940	9.9%
l	873	9.2%
r	813	8.6%
i	696	7.4%
s	567	6.0%
t	499	5.3%
u	258	2.7%
Other values (16)	1825	19.3%

Decimal Number

Value	Count	Frequency (%)
6	2	20.0%
8	2	20.0%
5	2	20.0%
0	2	20.0%
2	2	20.0%

Other Punctuation

Value	Count	Frequency (%)
.	271	73.2%
'	59	15.9%
,	40	10.8%

Space Separator

Value	Count	Frequency (%)
	12034	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	262	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	151	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	6	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	363389	96.6%
Common	12834	3.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	36799	10.1%
E	32773	9.0%
O	29514	8.1%
L	29423	8.1%
N	28734	7.9%
I	24008	6.6%
S	23939	6.6%
R	22162	6.1%
T	20421	5.6%
C	13141	3.6%
Other values (42)	102475	28.2%

Common

Value	Count	Frequency (%)
	12034	93.8%
.	271	2.1%
(	262	2.0%
)	151	1.2%
'	59	0.5%
,	40	0.3%
-	6	< 0.1%
6	2	< 0.1%
8	2	< 0.1%
5	2	< 0.1%
Other values (3)	5	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	376223	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	36799	9.8%
E	32773	8.7%
O	29514	7.8%
L	29423	7.8%
N	28734	7.6%
I	24008	6.4%
S	23939	6.4%
R	22162	5.9%
T	20421	5.4%
C	13141	3.5%
Other values (55)	115309	30.6%

State
Categorical

HIGH CARDINALITY HIGH CORRELATION

Distinct	51
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	43.9 KiB

CA	6893
TX	4095
NY	2953
PA	2849
FL	1920
Other values (46)	23597

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	84614
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AZ
2nd row	OK
3rd row	NJ
4th row	TN
5th row	CA

Common Values

Value	Count	Frequency (%)
CA	6893	16.3%
TX	4095	9.7%
NY	2953	7.0%
PA	2849	6.7%
FL	1920	4.5%
OH	1229	2.9%
UT	1166	2.8%
TN	1147	2.7%
WA	1050	2.5%
MN	1004	2.4%
Other values (41)	18001	42.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	6893	16.3%
tx	4095	9.7%
ny	2953	7.0%
pa	2849	6.7%
fl	1920	4.5%
oh	1229	2.9%
ut	1166	2.8%
tn	1147	2.7%
wa	1050	2.5%
mn	1004	2.4%
Other values (41)	18001	42.5%

Most occurring characters

Value	Count	Frequency (%)
A	14780	17.5%
C	8921	10.5%
N	8694	10.3%
T	7296	8.6%
M	5576	6.6%
I	4601	5.4%
O	4135	4.9%
X	4095	4.8%
Y	3796	4.5%
L	3394	4.0%
Other values (14)	19326	22.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	84614	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	14780	17.5%
C	8921	10.5%
N	8694	10.3%
T	7296	8.6%
M	5576	6.6%
I	4601	5.4%
O	4135	4.9%
X	4095	4.8%
Y	3796	4.5%
L	3394	4.0%
Other values (14)	19326	22.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	84614	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	14780	17.5%
C	8921	10.5%
N	8694	10.3%
T	7296	8.6%
M	5576	6.6%
I	4601	5.4%
O	4135	4.9%
X	4095	4.8%
Y	3796	4.5%
L	3394	4.0%
Other values (14)	19326	22.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	84614	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	14780	17.5%
C	8921	10.5%
N	8694	10.3%
T	7296	8.6%
M	5576	6.6%
I	4601	5.4%
O	4135	4.9%
X	4095	4.8%
Y	3796	4.5%
L	3394	4.0%
Other values (14)	19326	22.8%

BankState
Categorical

HIGH CARDINALITY HIGH CORRELATION

Distinct	51
Distinct (%)	0.1%
Missing	11
Missing (%)	< 0.1%
Memory size	43.9 KiB

CA	6476
NC	3320
IL	2944
OH	2785
RI	2541
Other values (46)	24230

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	84592
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SD
2nd row	OK
3rd row	NJ
4th row	SD
5th row	CA

Common Values

Value	Count	Frequency (%)
CA	6476	15.3%
NC	3320	7.8%
IL	2944	7.0%
OH	2785	6.6%
RI	2541	6.0%
TX	2457	5.8%
SD	2382	5.6%
NY	2197	5.2%
PA	1307	3.1%
UT	1133	2.7%
Other values (41)	14754	34.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	6476	15.3%
nc	3320	7.8%
il	2944	7.0%
oh	2785	6.6%
ri	2541	6.0%
tx	2457	5.8%
sd	2382	5.6%
ny	2197	5.2%
pa	1307	3.1%
ut	1133	2.7%
Other values (41)	14754	34.9%

Most occurring characters

Value	Count	Frequency (%)
A	11316	13.4%
C	10852	12.8%
N	8915	10.5%
I	7447	8.8%
T	5135	6.1%
O	5117	6.0%
L	4216	5.0%
M	4099	4.8%
D	3776	4.5%
H	3208	3.8%
Other values (14)	20511	24.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	84592	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	11316	13.4%
C	10852	12.8%
N	8915	10.5%
I	7447	8.8%
T	5135	6.1%
O	5117	6.0%
L	4216	5.0%
M	4099	4.8%
D	3776	4.5%
H	3208	3.8%
Other values (14)	20511	24.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	84592	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	11316	13.4%
C	10852	12.8%
N	8915	10.5%
I	7447	8.8%
T	5135	6.1%
O	5117	6.0%
L	4216	5.0%
M	4099	4.8%
D	3776	4.5%
H	3208	3.8%
Other values (14)	20511	24.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	84592	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	11316	13.4%
C	10852	12.8%
N	8915	10.5%
I	7447	8.8%
T	5135	6.1%
O	5117	6.0%
L	4216	5.0%
M	4099	4.8%
D	3776	4.5%
H	3208	3.8%
Other values (14)	20511	24.2%

DisbursementGross
Categorical

HIGH CARDINALITY

Distinct	2694
Distinct (%)	6.4%
Missing	0
Missing (%)	0.0%
Memory size	168.3 KiB

$100,000.00	2773
$50,000.00	2016
$25,000.00	1433
$5,000.00	1298
$60,000.00	1041
Other values (2689)	33746

Length

Max length	14
Median length	12
Mean length	11.495237
Min length	10

Characters and Unicode

Total characters	486329
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	685 ?
Unique (%)	1.6%

Sample

1st row	$80,000.00
2nd row	$287,000.00
3rd row	$31,983.00
4th row	$229,000.00
5th row	$525,000.00

Common Values

Value	Count	Frequency (%)
$100,000.00	2773	6.6%
$50,000.00	2016	4.8%
$25,000.00	1433	3.4%
$5,000.00	1298	3.1%
$60,000.00	1041	2.5%
$150,000.00	971	2.3%
$80,000.00	955	2.3%
$145,000.00	773	1.8%
$17,000.00	729	1.7%
$10,000.00	690	1.6%
Other values (2684)	29628	70.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
100,000.00	2773	6.6%
50,000.00	2016	4.8%
25,000.00	1433	3.4%
5,000.00	1298	3.1%
60,000.00	1041	2.5%
150,000.00	971	2.3%
80,000.00	955	2.3%
145,000.00	773	1.8%
17,000.00	729	1.7%
10,000.00	690	1.6%
Other values (2684)	29628	70.0%

Most occurring characters

Value	Count	Frequency (%)
0	217564	44.7%
,	43223	8.9%
$	42307	8.7%
.	42307	8.7%
	42307	8.7%
5	20651	4.2%
1	18647	3.8%
2	13317	2.7%
3	9574	2.0%
4	8893	1.8%
Other values (4)	27539	5.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	316185	65.0%
Other Punctuation	85530	17.6%
Currency Symbol	42307	8.7%
Space Separator	42307	8.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	217564	68.8%
5	20651	6.5%
1	18647	5.9%
2	13317	4.2%
3	9574	3.0%
4	8893	2.8%
7	7929	2.5%
6	7457	2.4%
8	6532	2.1%
9	5621	1.8%

Other Punctuation

Value	Count	Frequency (%)
,	43223	50.5%
.	42307	49.5%

Currency Symbol

Value	Count	Frequency (%)
$	42307	100.0%

Space Separator

Value	Count	Frequency (%)
	42307	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	486329	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	217564	44.7%
,	43223	8.9%
$	42307	8.7%
.	42307	8.7%
	42307	8.7%
5	20651	4.2%
1	18647	3.8%
2	13317	2.7%
3	9574	2.0%
4	8893	1.8%
Other values (4)	27539	5.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	486329	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	217564	44.7%
,	43223	8.9%
$	42307	8.7%
.	42307	8.7%
	42307	8.7%
5	20651	4.2%
1	18647	3.8%
2	13317	2.7%
3	9574	2.0%
4	8893	1.8%
Other values (4)	27539	5.7%

GrAppv
Categorical

HIGH CARDINALITY

Distinct	1425
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Memory size	126.2 KiB

$100,000.00	3257
$50,000.00	2934
$25,000.00	2153
$5,000.00	1426
$10,000.00	1330
Other values (1420)	31207

Length

Max length	14
Median length	12
Mean length	11.469662
Min length	10

Characters and Unicode

Total characters	485247
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	294 ?
Unique (%)	0.7%

Sample

1st row	$80,000.00
2nd row	$287,000.00
3rd row	$30,000.00
4th row	$229,000.00
5th row	$525,000.00

Common Values

Value	Count	Frequency (%)
$100,000.00	3257	7.7%
$50,000.00	2934	6.9%
$25,000.00	2153	5.1%
$5,000.00	1426	3.4%
$10,000.00	1330	3.1%
$60,000.00	1088	2.6%
$150,000.00	1051	2.5%
$80,000.00	988	2.3%
$15,000.00	905	2.1%
$20,000.00	902	2.1%
Other values (1415)	26273	62.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
100,000.00	3257	7.7%
50,000.00	2934	6.9%
25,000.00	2153	5.1%
5,000.00	1426	3.4%
10,000.00	1330	3.1%
60,000.00	1088	2.6%
150,000.00	1051	2.5%
80,000.00	988	2.3%
15,000.00	905	2.1%
20,000.00	902	2.1%
Other values (1415)	26273	62.1%

Most occurring characters

Value	Count	Frequency (%)
0	234078	48.2%
,	43234	8.9%
$	42307	8.7%
.	42307	8.7%
	42307	8.7%
5	20609	4.2%
1	16194	3.3%
2	11923	2.5%
3	7367	1.5%
4	6360	1.3%
Other values (4)	18561	3.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	315092	64.9%
Other Punctuation	85541	17.6%
Currency Symbol	42307	8.7%
Space Separator	42307	8.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	234078	74.3%
5	20609	6.5%
1	16194	5.1%
2	11923	3.8%
3	7367	2.3%
4	6360	2.0%
7	5694	1.8%
6	5310	1.7%
8	4480	1.4%
9	3077	1.0%

Other Punctuation

Value	Count	Frequency (%)
,	43234	50.5%
.	42307	49.5%

Currency Symbol

Value	Count	Frequency (%)
$	42307	100.0%

Space Separator

Value	Count	Frequency (%)
	42307	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	485247	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	234078	48.2%
,	43234	8.9%
$	42307	8.7%
.	42307	8.7%
	42307	8.7%
5	20609	4.2%
1	16194	3.3%
2	11923	2.5%
3	7367	1.5%
4	6360	1.3%
Other values (4)	18561	3.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	485247	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	234078	48.2%
,	43234	8.9%
$	42307	8.7%
.	42307	8.7%
	42307	8.7%
5	20609	4.2%
1	16194	3.3%
2	11923	2.5%
3	7367	1.5%
4	6360	1.3%
Other values (4)	18561	3.8%

SBA_Appv
Categorical

HIGH CARDINALITY

Distinct	2005
Distinct (%)	4.7%
Missing	0
Missing (%)	0.0%
Memory size	163.0 KiB

$25,000.00	2382
$12,500.00	1705
$90,000.00	1023
$4,250.00	985
$50,000.00	982
Other values (2000)	35230

Length

Max length	14
Median length	11
Mean length	11.284374
Min length	10

Characters and Unicode

Total characters	477408
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	443 ?
Unique (%)	1.0%

Sample

1st row	$68,000.00
2nd row	$229,600.00
3rd row	$15,000.00
4th row	$229,000.00
5th row	$393,750.00

Common Values

Value	Count	Frequency (%)
$25,000.00	2382	5.6%
$12,500.00	1705	4.0%
$90,000.00	1023	2.4%
$4,250.00	985	2.3%
$50,000.00	982	2.3%
$5,000.00	957	2.3%
$116,000.00	757	1.8%
$51,000.00	742	1.8%
$80,000.00	729	1.7%
$13,600.00	715	1.7%
Other values (1995)	31330	74.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
25,000.00	2382	5.6%
12,500.00	1705	4.0%
90,000.00	1023	2.4%
4,250.00	985	2.3%
50,000.00	982	2.3%
5,000.00	957	2.3%
116,000.00	757	1.8%
51,000.00	742	1.8%
80,000.00	729	1.7%
13,600.00	715	1.7%
Other values (1995)	31330	74.1%

Most occurring characters

Value	Count	Frequency (%)
0	192470	40.3%
,	42736	9.0%
$	42307	8.9%
.	42307	8.9%
	42307	8.9%
5	28769	6.0%
2	18959	4.0%
1	18682	3.9%
3	9861	2.1%
7	9728	2.0%
Other values (4)	29282	6.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	307751	64.5%
Other Punctuation	85043	17.8%
Currency Symbol	42307	8.9%
Space Separator	42307	8.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	192470	62.5%
5	28769	9.3%
2	18959	6.2%
1	18682	6.1%
3	9861	3.2%
7	9728	3.2%
6	8048	2.6%
4	7649	2.5%
8	7052	2.3%
9	6533	2.1%

Other Punctuation

Value	Count	Frequency (%)
,	42736	50.3%
.	42307	49.7%

Currency Symbol

Value	Count	Frequency (%)
$	42307	100.0%

Space Separator

Value	Count	Frequency (%)
	42307	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	477408	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	192470	40.3%
,	42736	9.0%
$	42307	8.9%
.	42307	8.9%
	42307	8.9%
5	28769	6.0%
2	18959	4.0%
1	18682	3.9%
3	9861	2.1%
7	9728	2.0%
Other values (4)	29282	6.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	477408	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	192470	40.3%
,	42736	9.0%
$	42307	8.9%
.	42307	8.9%
	42307	8.9%
5	28769	6.0%
2	18959	4.0%
1	18682	3.9%
3	9861	2.1%
7	9728	2.0%
Other values (4)	29282	6.1%

UrbanRural
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	330.7 KiB

0	24037
1	11759
2	6511

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	42307
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Most occurring characters

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	42307	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	42307	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42307	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Auto

Heatmap
Table

	ApprovalFY	BankState	CreateJob	FranchiseCode	LowDoc	MIS_Status	NewExist	NoEmp	RetainedJob	RevLineCr	Sector	State	Term	Unnamed: 0	UrbanRural
ApprovalFY	1.000	0.079	-0.041	0.076	0.065	0.042	0.112	-0.079	-0.025	0.062	-0.059	0.073	-0.055	-0.005	0.041
BankState	0.079	1.000	-0.007	0.045	0.214	0.125	0.243	0.021	-0.018	0.195	-0.036	0.718	0.036	0.006	0.205
CreateJob	-0.041	-0.007	1.000	-0.249	0.057	0.027	0.075	0.013	0.379	0.148	0.214	0.062	-0.029	-0.003	0.072
FranchiseCode	0.076	0.045	-0.249	1.000	0.191	0.082	0.111	-0.109	-0.272	0.071	-0.241	0.048	-0.039	-0.001	0.074
LowDoc	0.065	0.214	0.057	0.191	1.000	0.225	0.429	-0.178	-0.136	0.153	-0.036	0.199	0.006	0.002	0.237
MIS_Status	0.042	0.125	0.027	0.082	0.225	1.000	0.105	0.172	-0.058	0.237	-0.044	0.103	0.119	-0.002	0.195
NewExist	0.112	0.243	0.075	0.111	0.429	0.105	1.000	-0.215	-0.135	0.117	-0.020	0.224	-0.072	-0.012	0.220
NoEmp	-0.079	0.021	0.013	-0.109	-0.178	0.172	-0.215	1.000	-0.034	0.067	0.012	0.052	0.258	-0.001	0.088
RetainedJob	-0.025	-0.018	0.379	-0.272	-0.136	-0.058	-0.135	-0.034	1.000	0.030	0.259	0.047	-0.090	0.002	0.028
RevLineCr	0.062	0.195	0.148	0.071	0.153	0.237	0.117	0.067	0.030	1.000	0.046	0.195	-0.142	-0.001	0.269
Sector	-0.059	-0.036	0.214	-0.241	-0.036	-0.044	-0.020	0.012	0.259	0.046	1.000	0.114	-0.011	0.003	0.296
State	0.073	0.718	0.062	0.048	0.199	0.103	0.224	0.052	0.047	0.195	0.114	1.000	0.020	0.002	0.196
Term	-0.055	0.036	-0.029	-0.039	0.006	0.119	-0.072	0.258	-0.090	-0.142	-0.011	0.020	1.000	-0.004	0.211
Unnamed: 0	-0.005	0.006	-0.003	-0.001	0.002	-0.002	-0.012	-0.001	0.002	-0.001	0.003	0.002	-0.004	1.000	0.009
UrbanRural	0.041	0.205	0.072	0.074	0.237	0.195	0.220	0.088	0.028	0.269	0.296	0.196	0.211	0.009	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Unnamed: 0	Term	NoEmp	NewExist	CreateJob	RetainedJob	FranchiseCode	RevLineCr	LowDoc	DisbursementDate	MIS_Status	Sector	ApprovalDate	ApprovalFY	City	State	BankState	DisbursementGross	GrAppv	SBA_Appv	UrbanRural
0	0	163	21	1.0	0	0	1	N	N	31-Jan-98	1	0	22-Sep-06	2006	PHOENIX	AZ	SD	$80,000.00	$80,000.00	$68,000.00	0
1	1	84	6	1.0	4	0	0	0	N	31-Oct-93	1	62	30-Jun-92	1992	MCALESTER	OK	OK	$287,000.00	$287,000.00	$229,600.00	0
2	2	242	45	1.0	4	90	0	N	N	31-Aug-01	1	42	18-Apr-01	2001	HAWTHORNE	NJ	NJ	$31,983.00	$30,000.00	$15,000.00	1
3	3	237	4	1.0	0	0	0	N	N	31-Aug-07	1	33	6-Oct-03	2004	NASHVILLE	TN	SD	$229,000.00	$229,000.00	$229,000.00	0
4	4	184	0	1.0	0	0	0	N	N	8-Jun-83	1	0	17-Dec-99	2000	POMONA	CA	CA	$525,000.00	$525,000.00	$393,750.00	0
5	5	60	7	1.0	4	10	0	Y	N	1-Apr-12	0	44	26-Nov-93	1994	APLINGTON	IA	IA	$69,991.00	$70,000.00	$35,000.00	0
6	6	39	0	1.0	15	1	0	0	N	8-Nov-11	1	23	4-Jan-05	2005	DALLAS	TX	CA	$50,000.00	$50,000.00	$25,000.00	0
7	7	82	5	2.0	0	0	1	N	C	31-Jan-95	1	0	21-Nov-01	2002	HUDSON	NH	NH	$414,000.00	$414,000.00	$414,000.00	0
8	8	57	6	2.0	0	0	0	N	C	31-Jan-95	1	61	11-Jan-95	1995	WILLISTON	ND	ND	$112,500.00	$112,500.00	$101,250.00	0
9	9	25	1	1.0	0	0	1	N	N	30-Apr-07	1	0	23-Mar-04	2004	MESA	AZ	AZ	$50,000.00	$50,000.00	$25,000.00	2

	Unnamed: 0	Term	NoEmp	NewExist	CreateJob	RetainedJob	FranchiseCode	RevLineCr	LowDoc	DisbursementDate	MIS_Status	Sector	ApprovalDate	ApprovalFY	City	State	BankState	DisbursementGross	GrAppv	SBA_Appv	UrbanRural
42297	42297	57	2	1.0	0	0	960	N	N	29-Jun-01	1	0	8-Mar-96	1996	SACRAMENTO	CA	CO	$105,000.00	$105,000.00	$89,250.00	0
42298	42298	82	15	1.0	1	10	72590	0	N	30-Apr-06	1	44	15-May-03	2003	DALLAS	TX	TX	$50,000.00	$50,000.00	$25,000.00	0
42299	42299	10	2	1.0	0	1	0	Y	N	30-Jun-08	0	72	8-Mar-00	2000	CLARENCE	NY	NY	$670,000.00	$670,000.00	$670,000.00	1
42300	42300	82	3	1.0	0	0	1	N	N	31-Dec-05	1	42	9-Jul-03	2003	NEW YORK	NY	IL	$150,000.00	$150,000.00	$135,000.00	0
42301	42301	82	0	1.0	18	1	1	Y	N	10-Dec-96	1	23	7-Jul-09	2009	PITTSBURGH	PA	PA	$5,000.00	$5,000.00	$4,250.00	1
42302	42302	283	14	1.0	0	0	1	N	N	31-Jan-98	1	0	2-Mar-95	1995	PHILADELPHIA	PA	PA	$80,000.00	$80,000.00	$68,000.00	0
42303	42303	53	2	1.0	0	0	0	Y	N	3-Apr-91	1	42	6-Jun-07	2007	LOS ANGELES	CA	SD	$5,000.00	$5,000.00	$4,250.00	1
42304	42304	59	6	2.0	0	0	1	N	N	28-Feb-03	1	42	14-Mar-03	2003	COLUMBUS	OH	OH	$60,000.00	$60,000.00	$51,000.00	0
42305	42305	295	18	1.0	0	8	0	N	N	10-Dec-97	1	42	23-Aug-89	1989	CLOQUET	MN	MN	$294,000.00	$294,000.00	$220,500.00	0
42306	42306	84	4	1.0	0	8	0	N	N	31-Oct-89	1	72	12-Apr-11	2011	SAN GABRIEL	CA	NC	$67,500.00	$67,500.00	$50,625.00	0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Uppercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category